package com.app.util;

import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;

public class DBHelper3 extends SQLiteOpenHelper {

    private static final String Notice = "CREATE TABLE shiwu (\n" +
            "    id INTEGER PRIMARY KEY AUTOINCREMENT,\n" +
            "    title TEXT,\n" +
            "    content TEXT,\n" +
            "    date TEXT,\n" +
            "    status TEXT,\n" +
            "    pic Blob,\n" +
            "    username TEXT,\n" +
            "    userid TEXT\n" +
            ");";
    public DBHelper3(Context context) {
        super(context, "shiwu.db", null, 1);
    }

    @Override
    public void onCreate(SQLiteDatabase db) {
        db.execSQL(Notice);
    }

    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {

    }
}
